// ******************************************************************
// * Copyright(c)  Dextrys P&G Team
// * Description   : Schema_INV_CHECKING_PLAN_ITEM
// * CreateDate    : 2012/11/8 12:10:57
// * Creater       : InvCheckingPlanItemTable
// * LastChangeDate: 2012/11/8 12:10:57
// * LastChanger   : 2012/11/8 12:10:57
// * Version Info  : 1.0 For LKBOOK
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class InvCheckingPlanItemTable : TableInfo
    {
        public const string C_TableName = "INV_CHECKING_PLAN_ITEM";

        public const string C_CHECKING_PLAN_ITEM_ID = "CHECKING_PLAN_ITEM_ID";
        public const string C_CHECKING_PLAN_ID = "CHECKING_PLAN_ID";
        public const string C_WAREHOUSE_CODE = "WAREHOUSE_CODE";
        public const string C_WAREHOUSE_NAME = "WAREHOUSE_NAME";
        public const string C_LOCATION_ID = "LOCATION_ID";
        public const string C_LOCATION_CODE = "LOCATION_CODE";
        public const string C_PRODUCT_ID = "PRODUCT_ID";
        public const string C_CURRENT_STORAGE_QTY = "CURRENT_STORAGE_QTY";
        public const string C_STORAGE_OCCUPIED_QTY = "STORAGE_OCCUPIED_QTY";
        public const string C_ACTUAL_QTY = "ACTUAL_QTY";
        public const string C_CHECKING_PERSON = "CHECKING_PERSON";
        public const string C_REMARK = "REMARK";

        public InvCheckingPlanItemTable()
        {
            _tableName = "INV_CHECKING_PLAN_ITEM";
        }

        protected static InvCheckingPlanItemTable _current;
        public static InvCheckingPlanItemTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new InvCheckingPlanItemTable();

            _current.Add(C_CHECKING_PLAN_ITEM_ID, new ColumnInfo(C_CHECKING_PLAN_ITEM_ID, "CheckingPlanItemId", true, typeof(string)));
            _current.Add(C_CHECKING_PLAN_ID, new ColumnInfo(C_CHECKING_PLAN_ID, "CheckingPlanId", false, typeof(string)));
            _current.Add(C_WAREHOUSE_CODE, new ColumnInfo(C_WAREHOUSE_CODE, "WarehouseCode", false, typeof(string)));
            _current.Add(C_WAREHOUSE_NAME, new ColumnInfo(C_WAREHOUSE_NAME, "WarehouseName", false, typeof(string)));
            _current.Add(C_LOCATION_ID, new ColumnInfo(C_LOCATION_ID, "LocationId", false, typeof(string)));
            _current.Add(C_LOCATION_CODE, new ColumnInfo(C_LOCATION_CODE, "LocationCode", false, typeof(string)));
            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID, "ProductId", false, typeof(string)));
            _current.Add(C_CURRENT_STORAGE_QTY, new ColumnInfo(C_CURRENT_STORAGE_QTY, "CurrentStorageQty", false, typeof(decimal)));
            _current.Add(C_STORAGE_OCCUPIED_QTY, new ColumnInfo(C_STORAGE_OCCUPIED_QTY, "StorageOccupiedQty", false, typeof(decimal)));
            _current.Add(C_ACTUAL_QTY, new ColumnInfo(C_ACTUAL_QTY, "ActualQty", false, typeof(decimal)));
            _current.Add(C_CHECKING_PERSON, new ColumnInfo(C_CHECKING_PERSON, "CheckingPerson", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK, "Remark", false, typeof(string)));

        }

        public ColumnInfo CHECKING_PLAN_ITEM_ID
        {
            get { return this[C_CHECKING_PLAN_ITEM_ID]; }
        }

        public ColumnInfo CHECKING_PLAN_ID
        {
            get { return this[C_CHECKING_PLAN_ID]; }
        }

        public ColumnInfo WAREHOUSE_CODE
        {
            get { return this[C_WAREHOUSE_CODE]; }
        }

        public ColumnInfo WAREHOUSE_NAME
        {
            get { return this[C_WAREHOUSE_NAME]; }
        }

        public ColumnInfo LOCATION_ID
        {
            get { return this[C_LOCATION_ID]; }
        }

        public ColumnInfo LOCATION_CODE
        {
            get { return this[C_LOCATION_CODE]; }
        }

        public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }

        public ColumnInfo CURRENT_STORAGE_QTY
        {
            get { return this[C_CURRENT_STORAGE_QTY]; }
        }

        public ColumnInfo STORAGE_OCCUPIED_QTY
        {
            get { return this[C_STORAGE_OCCUPIED_QTY]; }
        }

        public ColumnInfo ACTUAL_QTY
        {
            get { return this[C_ACTUAL_QTY]; }
        }

        public ColumnInfo CHECKING_PERSON
        {
            get { return this[C_CHECKING_PERSON]; }
        }

        public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }



    }
}

